I’m trying to sync data from PagerDuty into our data warehouse (Snowflake). Specifically I’m trying to sync maintenance windows and services (but I might need more later). I’m able to use the Rest API to do a bulk export of all the data. However, I would like to build a sync process that would just export records that have been updated since the last sync, and the current API schemas for most objects does not make this possible. In order to do so I would need to have:
- A field that indicated when the record was last updated
- The ability to get records that have been updated later than some specified date
- (optionally) Output records can be sorted by updated timestamp